<?php 
 
 include ("global_files/report_customization.inc"); 
 include ("global_files/tables.inc"); 

 $i=0; 
$columns_array1[$i]["filter_name"]="convertable";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(convertable)";
$columns_array1[$i]["form_display"]="Convertable";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="brc_id";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(brc_id)";
$columns_array1[$i]["form_display"]="Brc id";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="designation";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(designation)";
$columns_array1[$i]["form_display"]="Designation";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="sign_name";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(sign_name)";
$columns_array1[$i]["form_display"]="Sign name";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="category_id";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(category_id)";
$columns_array1[$i]["form_display"]="Category id";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="form_no";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(form_no)";
$columns_array1[$i]["form_display"]="Form no";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="bank_ref_no";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(bank_ref_no)";
$columns_array1[$i]["form_display"]="Bank ref no";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="bill_of_lading";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(bill_of_lading)";
$columns_array1[$i]["form_display"]="Bill of lading";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="export_promotion";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(export_promotion)";
$columns_array1[$i]["form_display"]="Export promotion";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="transaction_type";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(transaction_type)";
$columns_array1[$i]["form_display"]="Transaction type";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="transaction_id";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(transaction_id)";
$columns_array1[$i]["form_display"]="Transaction id";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="fob_value";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(fob_value)";
$columns_array1[$i]["form_display"]="Fob value";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="commission_paid";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(commission_paid)";
$columns_array1[$i]["form_display"]="Commission paid";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="insurance_amount";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(insurance_amount)";
$columns_array1[$i]["form_display"]="Insurance amount";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="freight_amount";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(freight_amount)";
$columns_array1[$i]["form_display"]="Freight amount";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$columns_array1[$i]["filter_name"]="bill_amount";
$columns_array1[$i]["filter_table_join"]="_100351.brc_view";
$columns_array1[$i]["form_field_name[1]"]="distinct(bill_amount)";
$columns_array1[$i]["form_display"]="Bill amount";
$columns_array1[$i]["fetch_condition"]="";
$columns_array1[$i]["order_by"]="1";
$i++;

$db->query="begin work;";
$db->runQuery();
createNewFilters($columns_array1);
$db->query="commit work;";
$db->runQuery();

?>